Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_BACKUP_SET

This view lists information about backup sets for all incarnations of the database. It corresponds to the `V$BACKUP_SET` view. A backup set record is inserted after the backup has successfully completed.

Column | Datatype | Description
--- | --- | ---
`DB_KEY` | `NUMBER` | The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DB_ID` | `NUMBER` | The unique database identifier.
`BS_KEY` | `NUMBER` | The primary key of the backup set in the recovery catalog. If you issue the `LIST` command while connected to the recovery catalog, this value appears in the `KEY` column of the output.
`RECID` | `NUMBER` | The backup set `RECID` from `V$BACKUP_SET`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file. Use either `RECID` and `STAMP` or `SET_STAMP` and `SET_COUNT` to access `V$BACKUP_SET`.
`STAMP` | `NUMBER` | The backup set `STAMP` from `V$BACKUP_SET`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file. Use either `RECID` and `STAMP` or `SET_STAMP` and `SET_COUNT` to access `V$BACKUP_SET`.
`SET_STAMP` | `NUMBER` | The `SET_STAMP` value from `V$BACKUP_SET`. `SET_STAMP` and `SET_COUNT` form a concatenated key that uniquely identifies this record in the target database control file. Use either `RECID` and `STAMP` or `SET_STAMP` and `SET_COUNT` to access `V$BACKUP_SET`.
`SET_COUNT` | `NUMBER` | The `SET_COUNT` value from `V$BACKUP_SET`. `SET_STAMP` and `SET_COUNT` form a concatenated key that uniquely identifies this record in the target database control file. Use either `RECID` and `STAMP` or `SET_STAMP` and `SET_COUNT` to access `V$BACKUP_SET`.
`BACKUP_TYPE` | `VARCHAR2(1)` | The type of the backup: `D` (full backup or level 0 incremental), `I` (incremental level 1), `L` (archived redo log).
`INCREMENTAL_LEVEL` | `NUMBER` | The level of the incremental backup: `NULL,` 0, or 1.
`PIECES` | `NUMBER` | The number of backup pieces in the backup set.
`START_TIME` | `DATE` | The time when the backup began.
`COMPLETION_TIME` | `DATE` | The time when the backup completed.
`ELAPSED_SECONDS` | `NUMBER` | The duration of the backup in seconds.
`STATUS` | `VARCHAR2(1)` | The status of the backup set: `A` (all backup pieces available), `D` (all backup pieces deleted), `O` (some backup pieces are available but others are not, so the backup set is unusable).
`CONTROLFILE_INCLUDED` | `VARCHAR2(7)` | Possible values are `NONE` (backup set does not include a backup control file), `BACKUP` (backup set includes a normal backup control file), and `STANDBY` (backup set includes a standby control file).
`INPUT_FILE_SCAN_ONLY` | `VARCHAR2(3)` | This backup set record was created by the `BACKUP` `VALIDATE` command. No real backup set exists. This record is only a placeholder used to keep track of which datafiles were scanned and which corrupt blocks (if any) were found in those files.
`KEEP` | `VARCHAR2(3)` | Indicates whether this backup set has a retention policy different from the value for `CONFIGURE` `RETENTION` `POLICY`. Possible values are `YES` and `NO`.
`KEEP_OPTIONS` | `VARCHAR2(10)` | The `KEEP` options specified for this backup set. Options can be `LOGS` (RMAN keeps the logs needed to recover this backup), `NOLOGS` (RMAN does not keep the logs needed to recover this backup), or `NULL` (the backup has no `KEEP` options and is subject to the default retention policy).
`KEEP_UNTIL` | `DATE` | If the `KEEP` `UNTIL TIME` clause of the `BACKUP` command was specified, then this column shows the date after which this backup becomes obsolete. If the column is `NULL` and `KEEP` `OPTIONS` is not `NULL`, the backup never becomes obsolete.